package com.test;

import groovy.sql.Sql;

def gsql = Sql.newInstance("jdbc:mysql://127.0.0.1/teachdb", "root", "000000", "com.mysql.jdbc.Driver");

println "begin insert data..."
for(i in 1001..50000)
{
	String realname = "realname"+i;
	String idcard = "idcard"+i;
	gsql.execute("insert into MEMBERINFO(version, realname , id_card, id_type, isdel, ismodify, isstop, password, regtime)  values(0, '"+realname+"', '"+idcard+"', '1', 0, 'Y','N', 'yYSu0BSux2I6VPBZHaB6hf1Ldi0=', now())");
	println "now:${i}";
}
println "end insert data..."